SUPPORT / SAMPLES & SAS NOTES
Problem Note 36137: A Java exception occurs during SAS® 9.2 Phase 2 migration if your SAS® Data Integration Studio job contains nested SQL Join subqueries
 |  |  |  |  |
During the migration of SAS Data Integration Studio jobs from SAS 9.1.3 to SAS 9.2 Phase 2, the migration fails when the jobs contain nested SQL Join subqueries. A Java exception error message similiar to the following is generated:
ERROR Error migrating Multi_Nested_Subquery error: Encountered metadata exception.
com.sas.metadata.remote.MdException: Encountered metadata exception.
at com.sas.etl.migration.UpgradeJobAction.upgradeJob(UpgradeJobAction.java:734)
at com.sas.publicobjects.etl.Job.upgradeFromPreviousVersion(Job.java:282)
at com.sas.etl.migration.AbstractMigrationProcessor.executeUpgrade(AbstractMigrationProcessor.java:224)
at com.sas.etl.migration.ETLMigrationProcessor.migrateJobs(ETLMigrationProcessor.java:621)
at com.sas.etl.migration.ETLMigrationProcessor.migrate(ETLMigrationProcessor.java:194)
at com.sas.etl.migration.batch.BatchETLMigration.migrate(BatchETLMigration.java:272)
at com.sas.etl.migration.batch.BatchETLMigration.main(BatchETLMigration.java:186)
Caused by: java.lang.NullPointerException
at com.sas.etl.models.job.transforms.sql.impl.SQLMapping.loadSourcesFromOMR(SQLMapping.java:190)
at com.sas.etl.models.job.impl.BaseMapping.loadFromOMR(BaseMapping.java:1021)
at com.sas.etl.models.job.transforms.sql.impl.BaseQuery.loadSelectResults(BaseQuery.java:3211)
at com.sas.etl.models.job.transforms.sql.impl.BaseQuery.loadFromOMR(BaseQuery.java:3149)
com.sas.metadata.remote.MdException: Encountered metadata exception.
at com.sas.etl.migration.UpgradeJobAction.upgradeJob(UpgradeJobAction.java:734)
at com.sas.publicobjects.etl.Job.upgradeFromPreviousVersion(Job.java:282)
at com.sas.etl.migration.AbstractMigrationProcessor.executeUpgrade(AbstractMigrationProcessor.java:224)
at com.sas.etl.migration.ETLMigrationProcessor.migrateJobs(ETLMigrationProcessor.java:621)
at com.sas.etl.migration.ETLMigrationProcessor.migrate(ETLMigrationProcessor.java:194)
at com.sas.etl.migration.batch.BatchETLMigration.migrate(BatchETLMigration.java:272)
at com.sas.etl.migration.batch.BatchETLMigration.main(BatchETLMigration.java:186)
Caused by: java.lang.NullPointerException
at com.sas.etl.models.job.transforms.sql.impl.SQLMapping.loadSourcesFromOMR(SQLMapping.java:190)
at com.sas.etl.models.job.impl.BaseMapping.loadFromOMR(BaseMapping.java:1021)
at com.sas.etl.models.job.transforms.sql.impl.BaseQuery.loadSelectResults(BaseQuery.java:3211)
at com.sas.etl.models.job.transforms.sql.impl.BaseQuery.loadFromOMR(BaseQuery.java:3149)
Select the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Data Integration Studio Server Data | z/OS | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 |
| Microsoft® Windows® for 64-Bit Itanium-based Systems | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter 64-bit Edition | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise 64-bit Edition | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP 64-bit Edition | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft® Windows® for x64 | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Datacenter Edition | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Windows Vista | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| 64-bit Enabled AIX | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| 64-bit Enabled HP-UX | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| 64-bit Enabled Solaris | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| HP-UX IPF | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Linux | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Linux for x64 | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Solaris for x64 | 9.2_M1 | 9.2_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| SAS System | SAS Data Integration Studio | Microsoft® Windows® for x64 | 4.21 | 4.21_M2 | 9.2 TS2M0 | 9.2 TS2M2 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.21 | 4.21_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.21 | 4.21_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.21 | 4.21_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Microsoft Windows XP Professional | 4.21 | 4.21_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||
| Windows Vista | 4.21 | 4.21_M2 | 9.2 TS2M0 | 9.2 TS2M2 | ||